USE [IstoreInternet]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


CREATE PROCEDURE [dbo].[InsertProduct]
	@productTypeId int,
	@productName nvarchar(250),
	@productDescription nvarchar(500),
	@productPrice decimal(9, 2),
	@productSmallImage nvarchar(500),
	@productMiddleImage nvarchar(500),
	@productBigImage nvarchar(500),
	@productWarranty int
AS
BEGIN
	SET NOCOUNT ON;

    INSERT INTO dbo.Product (productTypeId, productName, productDescription, productPrice, productSmallImage, productMiddleImage, productBigImage, productWarranty)
    VALUES (@productTypeId, @productName, @productDescription, @productPrice, @productSmallImage, @productMiddleImage, @productBigImage, @productWarranty);
    
END




GO


